CREATE TABLE [dbo].[CartEvent]
(
[CartEventID] [int] NOT NULL IDENTITY(1, 1),
[CartItemID] [int] NOT NULL,
[RegistrantID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Title] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrantClass] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Complete] [bit] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CartEvent] ADD CONSTRAINT [PK_CartEvent] PRIMARY KEY CLUSTERED ([CartEventID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CartEvent_CartItemID] ON [dbo].[CartEvent] ([CartItemID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[CartEvent] ([RegistrantID], [EventCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CartEvent] ADD CONSTRAINT [FK_CartEvent_CartItem] FOREIGN KEY ([CartItemID]) REFERENCES [dbo].[CartItem] ([CartItemID]) ON DELETE CASCADE ON UPDATE CASCADE
GO